package com.example.lvsuo.mapper.cxg;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.lvsuo.entity.cxg.vo.AdmArticlesVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface AdmArticlesMapper {


    @Select(" select * from adm_articles aa,system_user su where su.id=aa.applicant and aa.status='Y' ")
    List<AdmArticlesVo> getAdmArticles(AdmArticlesVo admArticlesVo);


    @Insert(" insert into adm_articles values (null,#{applicant},#{name},#{number},'Y',1) ")
    void addAdmArticles(AdmArticlesVo admArticlesVo);

    @Select(" select last_insert_id() ")
    int getId();
}
